搜索数据库哪些表有某列
如:查询数据库中所有含Name列的表
select sysobjects.name
from syscolumns
inner join sysobjects
on syscolumns.id = sysobjects.id and sysobjects.xtype = 'u'
where syscolumns.name = 'Name'
如:查询数据库中所有含Name列的表
select sysobjects.name
from syscolumns
inner join sysobjects
on syscolumns.id = sysobjects.id and sysobjects.xtype = 'u'
where syscolumns.name = 'Name'